SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422969 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422969 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174029,509293,813516,799849,567175,850132,1047668,173253,900404,40457,614058,675424,79905,78407,553201,541931,24838,187365,186649,462815,649643,25229,349273,845548,574128,738631,925432,391067,356277,1045293,173883,452812,761254,247216,782372,495904,558878,474566,865139,706956,638658,921062,576451,343648,116012,401944,734135,584407,470798,150189,616403,943085,944553,81266,552474,1045192,721717,32322,202875,722181) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]