SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45146 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45146 [ RunTime:0.001901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003410,309046,533691,401067,1013472,136739,559558,135349,933495,159921,756045,282469,637423,933541,512499,820707,58121,1039439,252478,246262,27983,310715,508092,964831,971338,613532,697330,790280,76104,381218,979766,126185,79773,565585,430165,640375,784779,284607,538354,632163,316568,945146,112477,863957,319586,408998,76758,226529,112096,456097,232975,729724,789943,275334,602178,717604,189186,909350,57653,156224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]