SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 240071 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 240071 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544954,449176,720862,929979,669092,562886,482127,181384,681508,943328,735260,222261,975397,231612,412980,227283,22158,568559,44627,117439,949330,549258,97882,570613,560365,489854,444492,14043,211223,104703,150490,957794,540850,665873,257413,103122,399346,213149,696869,198473,357059,69129,572135,416066,832936,192982,834880,545852,827134,581987,922711,937754,783322,856380,787264,220534,58413,667298,260977,985182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 240071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 240071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]