SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017966 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017966 [ RunTime:0.002254s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142662,583313,222286,898388,135531,744901,629992,321632,140021,301477,665196,1038667,109762,901195,401997,284901,798208,568296,413847,93520,803719,545941,305625,777467,607446,453827,380182,973178,616960,329666,634928,1033581,440571,1043877,483798,38454,900117,475868,666132,240366,876581,244817,354797,214584,795349,186119,367004,151567,220710,700191,186959,56126,307764,811159,663241,658679,961743,591307,126125,708883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017966 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017966 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]