SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512938 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512938 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924645,176278,312137,447612,885293,372831,220727,819008,1008870,1016782,378916,298399,752593,152670,363240,613653,741259,628279,14802,224815,198416,100544,687156,91052,254732,740389,938872,889661,304866,393965,470942,282289,913910,672560,8448,330293,576154,399840,252673,842823,918183,14364,229554,283703,111422,785384,374155,309655,969304,472660,345375,143634,912372,715396,434080,764237,218385,354635,961104,881126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]