SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003061s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804423 LIMIT 1 [ RunTime:0.002150s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804423 [ RunTime:0.009968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309754,580073,485159,680522,517609,489122,572302,869662,358749,658784,198066,1010445,1016229,610969,893649,307509,485827,359188,614095,820922,720128,749279,620918,202130,617366,265530,410841,853493,999324,485418,1040181,633452,374271,968483,212469,753236,323120,178475,406538,274077,739078,229379,711136,457604,1039223,291588,799756,393575,512980,873610,297798,404149,648062,225070,594993,77551,269270,172767,732523,148692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]