SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434751 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434751 [ RunTime:0.002147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953342,105397,678778,863985,334626,995072,585539,983457,107808,929859,442484,559287,526448,4833,582710,820571,202266,492680,58421,967407,891500,32937,720001,196928,393183,204608,962933,927534,764610,739255,473567,237957,754685,599598,86518,125564,330454,170113,115996,301826,154791,502255,647412,285158,464026,1015417,544027,664391,267502,577367,958920,1046920,24249,79562,587431,728972,199953,1010298,993894,444548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]