SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014201 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014201 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412233,638706,486398,837090,639419,823919,255272,328272,380734,393145,893415,708905,565711,539034,695078,41118,492027,249965,1004798,119872,237202,734945,633943,900781,526471,368726,833700,574459,791357,49932,465136,585664,990900,434019,228179,977391,1007151,349635,140919,921648,558300,549655,599367,697113,784324,584655,119706,278538,152896,822625,128391,24202,215119,381895,425062,103935,946077,581810,780922,599506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]