SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020074 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020074 [ RunTime:0.002068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495684,777136,577036,268141,1047639,1043150,447067,341033,215218,798855,824050,250633,249521,890130,414123,341704,87881,460481,630993,809263,1024920,245485,810915,844621,938858,67396,114656,695944,254859,666257,119530,1021088,357476,875181,967655,286005,535050,52559,882313,391179,631698,921393,468562,363436,688751,962416,311484,494226,591887,671862,453265,434367,201548,879009,782502,834324,392165,520372,530440,946800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]