SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431089 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431089 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253521,236860,742877,286519,984056,642755,130026,687779,229633,750723,491900,284807,1001102,534133,776046,692756,692747,926247,653214,76067,662308,195273,703313,453078,116654,903675,639838,271954,83097,200252,168870,277130,785303,28874,996435,748408,719396,771551,481420,341511,176375,395606,318111,201334,289238,305231,826669,41517,195096,451156,348050,1035779,767833,345585,255369,998454,23825,3286,657975,618883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]