SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419094 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419094 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805147,38141,453864,904134,477865,874065,523540,617122,150029,752562,394587,871189,116231,356741,162620,800220,218769,730499,26706,291874,578084,618411,936972,723796,824806,909007,873274,129508,843069,246922,679717,394665,46917,260105,41097,593162,94627,31178,1024843,17874,255480,957703,291541,573000,718170,85283,1020786,875665,211468,451115,320678,931826,342832,332704,492627,453453,998629,433615,719959,324402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]