SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002760s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505505 LIMIT 1 [ RunTime:0.004980s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505505 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988083,175316,132322,122262,118949,1040395,241852,599464,89083,432077,32399,211485,578015,681829,32819,99512,417556,988961,847857,654884,401188,1022360,490485,346553,559551,506050,322632,34515,11576,500600,956942,597131,938262,675393,336775,264888,448618,135432,230476,311195,121046,890345,477173,121612,93705,825658,219208,889208,943309,528672,323717,262533,205400,536908,201582,943449,503619,236468,82819,89267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]