SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564821 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564821 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580351,182385,726786,230599,626671,89618,95621,773813,266633,583512,1032758,350364,142679,310948,481677,672396,931261,300129,109812,427916,257227,815273,582778,340436,986712,365555,986036,333626,814129,563379,1025880,580280,923731,569164,411056,485488,292410,257499,24000,129330,586608,1019983,71383,621415,62966,478622,611389,880603,875290,228756,604710,45865,622085,516158,341969,545098,954276,985672,375183,160805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002111s ]