SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356311 LIMIT 1 [ RunTime:0.001247s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356311 [ RunTime:0.004623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833408,364445,398961,743222,894397,52950,803665,631508,395305,524184,634156,312973,296294,518503,887101,481706,461260,595590,442386,721897,85961,610706,19288,557461,38683,770194,597931,964754,522171,438008,684555,114423,1031310,353427,939271,99386,357567,179801,727718,926781,345634,473335,658698,705288,528457,934817,12250,159340,970547,420578,489439,391604,376557,914477,742850,13488,423313,186495,171671,652684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001226s ]