SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42511 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42511 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855685,1011289,421282,440858,130024,478951,925528,374919,865620,802413,761911,946450,530416,853616,329007,181143,1047355,879670,364717,537521,731354,608012,357952,562215,335141,764641,737050,98269,456233,1019757,949698,467341,1034921,277925,502818,653276,113839,462421,88118,1038612,491782,629823,104114,714939,615387,393956,202556,806194,639448,894912,250404,188756,92669,347596,649442,421963,639288,691737,49413,426754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000811s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]