SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450110 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450110 [ RunTime:0.002067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766973,986553,417136,67250,580779,487876,184990,926647,381912,986300,290932,901525,915986,121949,210340,795295,347668,716388,365194,688503,39325,230472,623774,430510,560774,57844,868493,429141,702512,475055,536617,566947,654417,342533,446893,514829,973549,83601,547504,498300,550559,730858,931132,433206,1047539,260725,792180,308042,873726,620810,461742,239548,733806,175484,502751,388350,325886,837178,293654,180863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]