SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 672481 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 672481 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683551,768630,1029866,342156,132035,214134,659344,656621,931875,602737,43621,667159,294586,35281,107008,392046,487700,85452,615370,1016967,109878,24497,1035348,365227,581751,908912,964555,555836,318594,342064,898533,676924,702855,383175,523228,325634,1040660,114207,1038572,633757,622010,669660,601724,1044539,41530,904807,653110,483791,788816,381389,86697,17359,615290,841186,156632,423690,107056,730259,1034222,993355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 672481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 672481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]