SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421040 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421040 [ RunTime:0.005231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323207,105474,350367,1035864,243733,757192,100097,40017,293693,1019662,582639,234090,619343,948257,461726,563878,171929,808606,153384,259814,774546,90288,277329,1002396,260456,804549,539762,299725,1043757,275522,397958,981966,202593,386749,744551,539571,653915,585050,560175,936186,863032,102431,705185,192034,1003667,509292,73812,21228,438166,690489,88903,656686,608671,544157,760604,195397,529652,1013178,475090,625904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]