SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001622s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040294 LIMIT 1 [ RunTime:0.000639s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040294 [ RunTime:0.001495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495703,967395,701258,216723,1005962,901313,228486,648194,240495,414361,52023,847164,207067,385052,122359,154553,830797,305636,379247,879605,1032289,712841,29625,628923,854447,219621,106395,458947,416585,288362,671321,434899,836321,696012,708380,102208,624551,600058,979092,270175,996355,231290,942430,262978,313276,96413,860949,423425,446056,10555,1037161,1025342,22768,259772,534483,624160,391736,254701,396480,93399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]