SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504656 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504656 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222705,989307,999496,1016516,306535,790922,778749,750810,701360,667790,752438,174691,126228,448528,432346,851289,79494,349543,371362,1040674,772766,72680,803427,710459,349160,990250,435785,472228,437858,653222,214192,753529,912141,735574,773622,638503,878226,994453,94987,910196,1046478,898088,888584,4842,381668,482839,18102,787440,888518,905127,405266,918076,479385,367312,346387,673686,414899,543582,638597,158036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]