SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424013 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424013 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232111,746942,937626,205845,2503,39818,518391,221718,318005,647100,110375,924769,461447,1044390,716427,761848,604394,856400,43335,361777,673482,429505,987379,584426,255813,725357,950354,46263,940902,1022412,99830,669603,208075,465932,38973,685538,827319,676287,129900,659709,635549,661757,722851,63243,1008114,193990,819401,448492,266706,499769,624376,150427,897581,223884,218507,474337,567912,544697,822171,372968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]