SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042097 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042097 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954482,785287,905354,470807,250378,381545,559250,975717,89483,981998,420062,519142,250837,914125,444700,237510,254143,131732,218877,324206,940229,562621,952442,314816,23834,467346,81659,326160,1027088,809228,755924,817255,188778,724759,1009509,686321,897631,790306,195044,450937,31617,605718,479640,649130,385636,232892,976627,819398,330437,1017247,116169,273810,8353,928631,152987,424497,95486,649123,885178,935047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]