SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012707 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012707 [ RunTime:0.003612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205022,469102,566866,610263,670702,226668,241425,259093,543175,473290,9475,6484,723904,672639,462388,523858,993502,373229,424908,907238,344121,151970,462252,104168,373213,714998,38317,176351,767666,646738,137249,336547,856022,202895,407897,816256,686846,939379,589482,96301,327610,213307,863316,928251,571158,742402,934076,798933,817017,291435,320097,402352,193285,76979,702958,800385,522655,975500,928628,664262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012707 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012707 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]