SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001507s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548576 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548576 [ RunTime:0.005618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27767,896057,751191,26542,629109,989222,506137,401171,128507,198051,868560,1013488,1013622,913543,181641,963342,419323,294182,971560,572611,634574,705430,997536,706582,396378,17283,950634,181975,692367,431754,81651,929777,341745,664634,875667,847647,651146,697787,850071,374766,780432,933521,421166,437366,206949,623909,1038605,584118,279687,962127,891257,191823,305895,203617,798655,622326,272480,353797,255877,981021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]