SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 571010 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 571010 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209043,635481,296080,879447,162098,989977,717386,127596,356581,231575,167471,385894,83006,961514,314963,750271,974250,1023765,637225,815374,793231,506788,600200,1015988,352398,504313,414565,52963,943598,727188,408184,1021467,80233,387624,98170,171921,906328,770254,809900,613748,514495,288716,97338,891513,299833,897839,64935,321648,774563,356463,232381,908783,728717,1008053,492114,454008,485974,193950,447788,678937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 571010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 571010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]