SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41172 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41172 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506120,341604,394447,789514,352441,130500,79981,131573,707776,965866,322629,406290,558487,825701,708019,995536,396689,395860,246296,15298,512083,993045,400048,888546,233034,92807,302832,471924,823605,502138,402942,252762,1038760,439387,49543,539134,855177,1037388,173301,415662,412523,689489,1019515,446057,198063,338021,616510,37776,626741,440105,413974,684652,639686,328608,333135,311829,432798,95079,254028,1026443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41172 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41172 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]