SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574529 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574529 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513854,335075,373395,544976,983071,33630,558047,705529,133413,997543,874743,293658,41200,227819,707485,520035,500068,253579,201071,759951,826815,256142,901068,258199,398579,247222,906023,458342,589407,69788,322349,924734,563070,997821,227599,685227,329171,37967,738775,958673,238924,997078,829340,119445,961319,427531,882163,402578,611812,844475,688091,681941,705179,936420,108629,299936,975615,235575,420517,70182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]