SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002003 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002003 [ RunTime:0.005847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748615,279879,630391,232937,315640,500287,384786,300251,773733,464038,633531,252716,166592,354340,49577,869003,196176,86149,989055,859480,902599,212557,956928,988387,166678,223197,293096,101727,621581,244589,318562,982221,534138,854827,402681,169072,5079,476638,617752,658157,253290,230298,912103,784380,630848,226760,560230,995951,988366,248260,1018087,557488,722570,856397,135374,341652,75260,62032,876118,658995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]