SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045366 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045366 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116422,275557,195083,168594,780153,390844,401040,231867,64387,787553,310658,794900,945905,276397,153713,600783,920891,646819,981934,586278,876628,316841,374598,361412,271948,466360,369093,932997,208738,610618,769460,426958,584479,970812,761122,503665,206697,925990,937025,156743,913642,799850,774440,108109,509094,272446,733719,335401,949841,68742,893633,844098,708207,475478,372849,864608,465521,677703,300041,199790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000913s ]