SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438840 LIMIT 1 [ RunTime:0.003885s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438840 [ RunTime:0.002694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495222,870817,22755,710728,554273,471493,295127,856285,394009,109428,869942,332106,65167,984939,934896,107933,956649,144035,303009,1020888,105189,319362,248117,65284,407882,183422,400406,39464,547473,125105,51098,749996,996947,779743,150675,1036262,693509,821503,677191,719960,201005,390281,657733,932477,981912,88224,331839,217189,633660,37314,662660,267166,1020568,977355,452989,956973,13706,276760,826367,995812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]