SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043325 LIMIT 1 [ RunTime:0.000651s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043325 [ RunTime:0.002471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132627,326492,893974,41990,430602,889562,568958,142916,63869,56446,878976,585995,155518,922038,936073,728878,871321,545962,502965,130899,863515,676153,588970,962138,43383,131596,306780,675799,206559,810906,110755,473955,550098,524140,428239,5598,114496,460356,823689,206725,839774,558054,5649,46247,541937,845030,979365,550858,77658,1040859,777361,297955,603287,960176,1044922,1738,704108,625421,684539,917270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.022942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043325 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043325 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007915s ]