SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017880 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017880 [ RunTime:0.003609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92742,527858,989354,293643,778464,649345,1022714,928166,286087,949988,465022,647387,912719,972682,444782,281382,985762,629122,272068,578807,1007518,10963,965118,526830,591276,47906,48574,631030,573341,117496,738892,930006,504315,206791,146234,628757,152357,144394,688410,802016,863760,689728,415598,1009950,283580,13341,686090,1038226,805740,933801,205870,103433,563350,697399,179073,962642,559497,752600,699833,575518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]