SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 222014 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 222014 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185765,143556,843032,343721,341970,845527,595220,868506,327075,376117,36253,898005,363995,901818,938200,304197,517281,731439,105147,201643,544523,1009493,844921,4942,495547,219658,80453,624063,521924,148224,1023569,621966,741180,967340,772072,341318,861885,204278,45952,224552,371863,1043480,526780,507157,106127,148647,401074,1003558,99142,860494,435834,879554,476794,123220,725339,469868,130046,538226,267959,158900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.030215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 222014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 222014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000993s ]