SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589628 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589628 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105856,982914,625637,250187,819783,1001300,783962,12243,771475,278935,521402,792807,458937,582632,342321,515589,481877,114390,909540,951397,907140,969554,956059,48911,352365,827408,653529,44457,543131,310150,705330,781605,486348,358980,445816,460415,817956,837254,998566,282884,882344,657093,209779,568573,496899,293511,676735,228768,726786,410820,463259,269591,355649,841343,758441,595058,41035,404040,249014,331662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000358s ]