SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 379971 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 379971 [ RunTime:0.002568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038090,318135,42524,40696,191562,876290,477311,248950,1021798,849352,636925,681191,976679,133518,945779,920286,852526,878239,718388,122960,755215,519067,508719,934709,433226,678670,481585,1003330,671959,792273,492923,631473,1016895,246984,895906,817931,335527,1025158,205850,604247,287577,453551,359945,407421,745788,1033300,546331,758744,21091,359275,470908,548940,762914,987543,671791,136885,120254,1046361,396989,789412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 379971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 379971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]