SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023151 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023151 [ RunTime:0.002108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043675,897431,267028,679283,21768,122313,814878,88800,276741,84986,917107,20726,266689,727028,553430,27594,159708,911121,604152,260229,169832,722850,159767,199433,110391,199978,990107,979438,606469,260779,137577,802877,485492,952284,223094,328887,351264,601906,213153,591269,913822,765839,674918,423801,648405,465849,489141,565384,905299,329219,175694,713461,1024615,421441,848706,965659,500465,916049,1034778,199035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]