SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040366 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040366 [ RunTime:0.002998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512810,892220,928499,891903,174000,595975,209792,763247,830253,813620,797059,104659,681993,491553,905722,651340,793200,447295,554408,445396,679987,847342,159792,575426,735012,476460,56257,669767,778975,802538,989361,149062,349337,860816,316459,941536,851573,218345,804192,371766,480053,208140,687929,955225,235121,34030,286826,223982,630341,657518,841518,682847,679533,314336,699414,871481,513867,692669,606122,231966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]