SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044222 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044222 [ RunTime:0.002874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501814,845171,43677,618229,421127,1007028,768239,996376,153186,558896,783673,363420,283177,918459,950885,379681,891307,375973,928779,1014302,126576,372743,582703,643016,634433,69389,983674,984455,425366,930630,816850,1013342,981407,1041799,288349,773891,467684,788039,143817,255287,780779,236726,153686,960676,951258,986563,933173,582832,24815,492556,578386,482844,927299,386270,671374,444306,28620,820030,558118,984676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]