SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43765 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43765 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92118,407362,925955,985377,201339,832548,710368,242755,934164,970948,434076,83472,849835,502741,86145,592148,1022510,964009,692810,20255,615409,711372,328930,534962,63932,615361,895305,262789,694030,812223,698171,430746,298054,740104,1020768,627831,110999,789633,981064,368638,206432,431659,646098,228025,673265,1034456,30631,933545,780945,175181,721579,397136,379437,827774,355505,190997,457439,423734,798770,371654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]