SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302993 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302993 [ RunTime:0.005808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935001,259026,875896,950093,661149,391308,449969,50858,171200,87559,515038,444022,799374,1034145,882716,398246,102268,88813,521165,398110,436058,950467,667820,439944,748553,660965,881079,800280,537704,595815,806462,744713,70170,549161,1048333,773069,291801,205491,352026,402329,12283,474871,700046,474326,563922,912572,636282,1034927,687546,949687,854862,536060,855848,639081,646619,740904,890679,1027893,860887,469942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]