SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533984 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533984 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618916,706256,503350,578471,1031438,483358,864755,125861,870027,359171,614361,991486,613069,453487,733769,1033137,3913,1048350,513411,867377,960606,455088,402186,14657,340339,1023953,97896,1013953,722760,1035507,147409,734157,728441,635347,987522,82703,263243,473512,525156,400607,514201,348263,365573,202514,957895,169630,102229,118964,364735,832391,545686,256536,225420,265974,577907,79461,17231,560179,230071,881805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002282s ]