SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040760 LIMIT 1 [ RunTime:0.000506s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040760 [ RunTime:0.002197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628250,413790,143680,735444,730595,919234,499731,847546,953728,456069,621986,211884,933791,418330,254082,396035,464152,995198,672198,180222,51478,831483,112945,471260,754588,102935,475055,412138,745515,39366,96824,491190,184467,664471,289521,856770,908323,694199,683585,195264,776114,97261,28224,44731,763247,83771,893711,606223,629087,325098,871158,714062,747166,628348,12785,501770,275706,541763,169212,309185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003362s ]