SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420527 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420527 [ RunTime:0.001933s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121824,781121,1034701,858307,738091,873049,750822,181087,598183,902171,1038830,488293,364442,473971,333699,1048217,701109,153719,20272,559050,452013,143784,483619,207974,1002508,886873,960403,872651,295618,32085,281852,421979,901146,88786,614063,963895,182830,912608,815795,357429,873818,530935,1015747,312146,262119,509222,1016771,688741,233945,1046604,621281,23948,791864,993032,993215,852546,216054,53383,128266,61434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]