SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515401 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515401 [ RunTime:0.002062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243361,825526,861343,108190,746199,570699,702988,199934,124784,162545,256761,720404,328572,467092,761686,1048286,35944,1048877,825615,131909,211944,616825,979184,735031,831555,304567,838356,741928,1018686,428582,508948,326256,40245,60601,326813,509031,1013198,526626,952938,837091,753201,165707,865982,234184,481058,265359,952494,87770,557760,91551,143880,979751,549416,841720,383046,105122,321822,678583,430641,743879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001430s ]