SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 914796 LIMIT 1 [ RunTime:0.000811s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 914796 [ RunTime:0.003195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591001,610371,841524,204166,662004,909053,636197,826732,808905,722200,207423,916577,370424,390684,835675,634254,403581,752126,125454,814749,483123,876947,533898,214885,594779,715245,52857,780754,351731,429108,728222,628075,649443,310641,1037432,806381,695270,868933,559841,514854,666871,274388,23134,730069,538489,814077,539314,409391,495990,492498,145250,28274,123036,853702,965033,731399,217732,403076,762392,463668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 914796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 914796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002794s ]