SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001768s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410600 LIMIT 1 [ RunTime:0.000550s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410600 [ RunTime:0.004108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890460,131730,571265,932012,663793,552024,178504,130505,87297,260467,2553,912897,99263,576293,199827,470584,832008,1015324,3139,17949,368785,824024,327501,931898,821478,470218,85302,769986,368996,902303,802052,882944,95265,313741,705552,634165,209793,7946,936840,677002,371352,989034,615447,943816,131503,304602,938834,616252,843643,58130,734014,442362,752313,989325,625410,322273,790577,551548,773021,408238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000969s ]