SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452100 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452100 [ RunTime:0.002290s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427190,759025,595747,419338,694206,143527,762720,565364,274533,330683,146452,330934,857858,276773,783258,175218,861428,515972,534455,440325,310954,270441,908958,710044,579170,135451,393515,180278,634148,481613,408071,819050,1037685,802898,996508,240375,848046,848448,895609,557725,534252,119193,296485,445974,727585,379496,823392,85409,159408,678608,622049,826389,110611,525858,1023775,271731,368305,405321,626391,361715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002337s ]