SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320901 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320901 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550716,992740,459347,716853,124589,817513,189115,818566,514076,739080,497930,456989,303862,1029247,771733,697369,238553,131221,231918,563473,813995,332824,55511,607091,414976,259401,586716,443304,382123,549830,576857,565686,21393,852731,698179,298535,456323,400041,415924,238041,555167,318738,348238,609145,610117,814166,89783,289453,802215,173641,564414,735447,24666,207481,745726,12655,704521,402016,820615,187317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]