SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001768s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36838 LIMIT 1 [ RunTime:0.002232s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36838 [ RunTime:0.003456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475083,177042,702382,92543,669825,739622,695963,419677,719482,420399,851020,821836,240027,395255,761621,774396,502345,818001,1006308,227976,147935,485167,408693,796344,160282,869442,189923,321656,443282,973420,323906,444927,317568,293885,803568,285833,846172,6262,685289,111840,332529,611638,663225,339097,1033864,198090,335580,220135,643791,279478,785228,935090,900397,865927,774771,933403,245625,711404,34990,945222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000759s ]