SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001711s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512309 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512309 [ RunTime:0.003927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726039,577850,343677,347995,1031517,1043805,996365,880994,4542,511653,530253,394658,111440,847150,227162,902823,634889,398294,631448,303857,475888,538406,816702,912111,175915,538932,145883,338795,331371,537230,895626,897604,245855,308857,790131,421698,174087,570453,273459,814142,770472,903639,658634,156181,101912,192789,92077,963228,788508,217374,590881,301546,47549,269628,221771,367547,952185,368080,592825,55829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000779s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]