SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485993 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485993 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516118,989332,235536,656122,563513,967484,211563,642076,1046013,315082,748121,353044,760970,568497,77460,85984,176058,275966,340388,334423,914704,1041845,825627,1018339,235434,357489,386142,604906,750954,386007,491110,201022,1028485,416532,467021,598419,75934,504836,375161,13310,183982,835741,474592,664874,220368,643982,263379,586333,616216,949518,403654,1019351,826230,6655,78773,565260,60259,854667,1032165,841401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]