SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984116 LIMIT 1 [ RunTime:0.000520s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984116 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24565,974372,1039283,958911,78418,410280,1005159,4943,1003181,943377,154166,105469,311269,143962,270512,777007,690815,284825,131963,188614,110361,593096,479818,61242,46189,768265,454377,403906,856994,208852,1011546,485010,1021052,230321,15191,712364,575858,956190,572413,608025,924391,762163,677452,902244,812253,374053,306530,676747,299288,539048,290589,435455,548433,329253,606487,504292,295819,691743,208306,666620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]