SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317058 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317058 [ RunTime:0.002183s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319578,463193,978952,917307,992241,252059,980588,625148,713412,1043991,460020,493560,912109,283952,101410,718477,400242,900919,546752,13624,264776,315139,326808,76102,775929,126167,681712,132155,105480,859470,945061,994584,77377,295614,907881,535284,512224,559476,699707,35903,693868,991237,334813,20012,509939,252816,1042691,847355,168311,703833,194832,477662,487093,556665,181814,920628,442239,546295,583885,96322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]