SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001244 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001244 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407128,70133,546249,981239,703465,1018150,133058,153609,3658,923931,969589,700751,351163,11453,584752,196999,974781,902197,904051,169561,11981,584160,114165,980771,269772,3398,771921,160745,375680,493808,652993,234921,141024,147126,32465,959865,470596,897494,461103,712038,162468,794889,228114,137636,398481,814516,345813,53254,469601,645546,261800,603578,979143,415952,307823,341937,557220,301982,14046,1034374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]