SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001763s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52923 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52923 [ RunTime:0.002626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518609,273626,129914,100899,331522,873042,599510,904526,924854,341641,343373,286929,75745,600207,982272,347541,386876,966897,326401,84832,37529,129687,897375,454513,688777,344505,196423,401236,972568,82256,451022,59088,453561,805360,808129,637189,489903,812169,26137,101151,15672,611482,606579,560554,403748,664945,426548,407046,228697,954461,125531,157801,264558,660800,894886,485663,592859,568547,345652,875386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]