SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039461 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039461 [ RunTime:0.002832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566703,1023916,367852,836137,945416,379581,919982,46714,368910,261915,388759,211536,523238,202654,662986,391011,988606,394812,57617,952847,136466,380539,368209,588310,354904,378442,168256,877554,1019527,521721,1003206,968768,29171,762833,269004,951784,838384,791894,956756,513581,655196,193721,243039,548059,189730,721154,320789,664879,69089,840398,923524,123118,516447,790808,357484,261127,596706,185141,746185,889287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]