SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 133181 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 133181 [ RunTime:0.001473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157699,388586,408720,1040812,704522,601866,150093,705689,11225,635610,361403,915168,179801,570038,74006,358304,270891,836060,463068,812318,425593,78982,293765,313632,738853,498467,699641,630350,494550,46621,432817,25310,988130,352307,380555,910929,633643,283062,423088,102540,484900,764780,205683,897541,808715,755191,695728,310033,282290,870637,118199,159262,564784,93563,657310,434057,509573,753798,1028615,675210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 133181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 133181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]