SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804271 LIMIT 1 [ RunTime:0.003288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804271 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802178,9955,1020466,688746,681609,822323,343968,1018545,555028,814578,620071,581350,820333,832655,583055,1013279,918514,988326,656079,829805,839588,575748,24889,553770,185822,913220,531538,96660,358776,278216,543452,743646,793993,527047,240217,11504,1037269,24411,322091,734043,553920,989883,73546,960380,151367,853051,704613,979270,117750,791048,730752,1011978,769580,364722,1016371,1016284,695210,228530,512099,947793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001893s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]