SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003017s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423478 LIMIT 1 [ RunTime:0.001153s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423478 [ RunTime:0.002682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203345,1019793,201854,501693,460142,549145,20981,746826,740728,641646,562159,180403,269222,981277,44867,490688,241242,998054,175519,1017629,178011,500397,746212,724193,808805,844014,871188,755327,684439,1010788,828091,670692,631276,494873,727775,1028726,31611,228675,993273,721608,363059,710055,8161,1029589,485243,329546,1103,110931,656260,871334,408934,765343,1011112,404555,646852,632252,251259,605182,614933,476677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003739s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]