SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 609420 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 609420 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040103,218752,220206,105520,939812,394493,1002260,505029,467197,554005,966953,565778,409625,314910,334155,708633,552335,935258,660325,328691,552225,1009197,407147,149303,43061,757508,75314,1029359,732948,270215,620081,896890,499874,657004,459767,1010283,844188,566338,10218,525872,510807,790183,387535,878389,771706,856288,567649,10006,280901,115649,452619,336543,148083,257379,130776,696352,736816,762072,692420,801036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 609420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 609420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]