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` = 533299 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533299 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446343,609931,130989,584929,559287,870859,757492,964295,997111,892102,1003267,452270,740518,740612,953747,924507,540904,873335,306460,183643,351222,618102,411282,633498,659381,545439,112060,480438,235006,1023483,343283,278319,221454,925995,114273,555549,684188,631346,128916,744045,310983,862054,797160,765576,563955,306252,587174,217485,913098,818924,886358,391616,250319,882814,642149,871067,722599,924008,356120,429155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000911s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000846s ]