SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804206 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804206 [ RunTime:0.002606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191142,351583,761869,153325,983670,976522,671062,425679,427183,994941,74640,962768,933957,159543,344297,468544,1017319,287322,526482,560969,849555,153626,425449,55699,310944,604291,452291,243236,330602,531282,33337,141348,583649,423287,262216,495659,477354,930315,866192,668321,60426,758253,765358,691351,703604,345298,447901,607336,659662,715388,574876,772863,78404,112003,926014,328299,364922,205524,214896,150710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]