SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011571 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011571 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734760,780194,1266,605452,579393,503240,253130,618230,479184,423379,513178,2003,131152,102593,188763,708643,313357,601826,503212,376144,3434,447873,922395,611307,32996,461671,42562,895268,822810,384794,983276,309494,378219,535534,308153,927920,770795,227793,39371,898527,420224,308402,21410,940969,378473,721827,12352,165072,738893,476924,533219,1002261,827574,34787,700219,443443,880840,641867,334349,784429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000375s ]