SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806238 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806238 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710655,354495,295396,218573,551817,947134,885472,450483,52613,999630,254642,534720,672707,694368,979744,685512,325632,195991,197091,59304,188445,474783,8477,116638,864249,746279,10904,41429,914653,452986,326505,633055,386218,857059,118102,23527,613977,97659,642012,112086,952990,874313,713196,788060,448111,119417,928027,365111,35491,434528,786542,52285,563267,157407,739,478666,996538,972718,831522,1021962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]