SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012164 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012164 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839961,489258,578199,388901,474125,568484,1012473,853130,674017,24554,180130,838042,221090,308054,667658,326986,273889,769800,605435,167311,770709,121320,764472,995319,763255,22439,614496,812952,849076,360647,1555,350316,569098,631255,775579,989398,333537,727766,120350,629679,977941,789193,414099,1036958,44243,912014,333853,271083,431794,22309,25754,42183,475273,834841,1043363,208775,952229,213625,841096,676677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]