SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038083 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038083 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430587,1043763,542264,356549,138086,782097,209181,604310,87249,563708,709036,633247,322523,668746,681405,952653,464944,729931,206049,511185,978482,717669,239402,956329,806182,632767,578762,528909,1008964,286335,159737,427532,227559,857362,45785,279254,613531,451656,661630,470076,829670,335747,760016,775176,247553,190346,896816,595595,848876,80534,770460,690588,480640,21151,302505,645080,948655,103293,372748,850792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]