SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414538 LIMIT 1 [ RunTime:0.000652s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414538 [ RunTime:0.002285s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923981,784538,1034684,579624,682376,112605,165675,854080,622510,954638,851702,650987,217704,898590,756423,95826,535911,868614,991950,922214,396199,10845,327582,820351,997679,713276,493496,58621,381106,1022618,905450,18543,230986,711130,384557,251724,381589,20768,958775,274839,187200,329516,436547,977193,106535,351956,875722,707745,961362,640530,832555,362807,397999,1030812,760091,209851,237302,733624,110289,497681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001144s ]