SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505657 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505657 [ RunTime:0.002447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399128,118144,507739,1015266,523490,697621,567716,723959,320767,256348,292466,904081,299725,1038889,307456,198838,44999,247440,970716,241614,163102,11351,330280,882300,531246,710436,17016,799103,416191,934113,466200,238766,935440,789715,264806,205265,269970,986269,143686,26285,955986,856657,249032,259222,114450,808809,973601,728899,509950,77729,74361,211209,859746,343123,988984,387897,47450,917529,488037,598254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505657 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505657 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]